﻿alter table Cms_Wsm_MaintainBill add IsInWorkingTime bit 
update Cms_Wsm_MaintainBill set IsInWorkingTime = 1

update Cms_Wsm_MaintainBill set IsInWorkingTime = 0 where (convert(char(5),BeginDate,108) < '08:30' and convert(char(5),BeginDate,108) <> '00:00')
or (convert(char(5),EndTime,108) > '17:30' and convert(char(5),EndTime,108) <> '00:00')

go

alter table Cms_Wsm_InstrumentAssembly
add ReadNumManageMan	uniqueidentifier,
ReadNumBeginDate	datetime,
ReadNumFrequency	decimal(5,2)

go



